Initial Process – Psychometric Test

- You will first receive a link to complete a psychometric test.

- Answer all questions honestly.

- Some questions may be repeated in different forms — ensure your responses remain consistent.

Round 1 – Technical Interview (TR-1)

Panel: 3 members

BigQuery: 

- Handling nested records.

- Scenario: Each record must include a cust_id.

- Customer’s contact details should be stored as a nested field named customer_info, which must include two fields: phone_num and email_id.

- Task: Write the DDL statement to create this table in BigQuery.

- Focus area: Working with nested values in BigQuery.

Airflow: 

- How to create a DAG.

- Different operators used.

SQL:

- Joins.

- Primary Key concepts.

Project Discussion:

- End-to-end explanation of your project work.

Round 2 – Technical Deep Dive (TR-2)

Duration: 30-minute call

Panel: 2 members

Project-Related Scenarios:

- Detailed discussion on end-to-end project workflows.

Reverse Migration:

- Approach if a company moves data from cloud to on-premises.

Multi-Region Challenges:

- Handling infrastructure and resources across different regions.

Cross-Project Migration:

- Access requirements when working in a development project but needing data from a production project.

Data Warehousing Concepts:

- Slowly Changing Dimensions (SCD) Types 1, 2, and 3.

- Change Data Capture (CDC) logic.

General Questions:

- Team structure.

- Daily work responsibilities.

Round 3 – HR Discussion

Mode: HR may connect via call or email.

Discussion Points:

- Salary expectations.

- Offer-related details.

Important Note:

- HSBC typically has a long interview and offer finalization process.

- They usually do not consider counteroffers, so it is important to communicate your expectations clearly from the beginning.

Final Outcome:

- Selected for the role in Bangalore with a package of 18 LPA.

- After negotiation, the offer was revised to 19 LPA.

- Despite holding an existing 24 LPA offer and having 4+ years of experience, this was the maximum offered.